Other examples of a Prefilter

In the previous example Building a simple Prefilter we specified equals in both Conditions to find an exact match for 2 and for V (this search function is case sensitive).
However, you have other alternatives such as like which will find approximate matches – you will need to include the wildcard %.

For example, you may want to find any Department beginning with Vic:

This shows a filter using 'like' rather than 'equals' (Department like Vic%)

 

Note the use of the wildcard %.

You might also use the between search option when looking for numerical values:

 

Simple filter using 'between'. This one is searching the Gross (salary) field for values between 3000 and 5000.

 

 

 

Simple Prefilter results

Creating complex filters with Prefilter